UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rXTebY7Y1xfd1vgYqW67yAjuyBDK2ECFaZDdgxhhrFQ='
WHERE
key_id = '9aa298f11691d36af8d92f89e6ba9d73a6b0f59b391ddd0f1f54a27fd1ed074b'
AND (
token = 'rXTebY7Y1xfd1vgYqW67yAjuyBDK2ECFaZDdgxhhrFQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)