UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7oobrk4rYAqKe3SPsHuVUU0xRNcsONVXj0NRUNyBclI='
WHERE
key_id = 'ce0c49bbf28175aa0a8df2fa893eab696694a02ae73224e43f13f9f058cbe551'
AND (
token = '7oobrk4rYAqKe3SPsHuVUU0xRNcsONVXj0NRUNyBclI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)