UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HBL66NcnkN0mYY/nkGFZb9oR+N1obhcIM+j+eMU3K58='
WHERE
key_id = '406b8c3eab9b052a0f1205f20321fb4753eb40760be3eaddc0d0df1b53295a6e'
AND (
token = 'HBL66NcnkN0mYY/nkGFZb9oR+N1obhcIM+j+eMU3K58='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)