UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XfJdJUE9b3MUmOIFExyq6WpDGiggYXenIJPzhQd2FcU='
WHERE
key_id = '00833ce43548d1fc8c7a6d250a09985817a50a49e5c028cb594728fe8fb10965'
AND (
token = 'XfJdJUE9b3MUmOIFExyq6WpDGiggYXenIJPzhQd2FcU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)