UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'V7IOZ+yyV7kcaKIs4S3478R5Yf+HlukSdpCAoy8Znl4='
WHERE
key_id = '936c11be4af3b62aad1d6aff03fcb1c7337242de0ee10f96d1b83772bda9bec3'
AND (
token = 'V7IOZ+yyV7kcaKIs4S3478R5Yf+HlukSdpCAoy8Znl4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)