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