UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6goIifPXe6qpLrYr5rDTAWdYuIX1N97T9ES3WtkZvQU='
WHERE
key_id = 'e2a0d5a72c114e3154f031b1c634c37a142c1ddf0c1974da782323a21600e77e'
AND (
token = '6goIifPXe6qpLrYr5rDTAWdYuIX1N97T9ES3WtkZvQU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)