UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kjn+c04ECkiFKQagyAsyjGW8DN/s7SWTVj8FpN+9G3I='
WHERE
key_id = 'e8ecdb16e2776db7a25872b3b7e62d8fdc648444c607d5cfc988ad4cc3f8d71b'
AND (
token = 'kjn+c04ECkiFKQagyAsyjGW8DN/s7SWTVj8FpN+9G3I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)