UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tB0KoqRYbMVAwZO7uDRRTB/KR3B4Z7GCw06YR9e+D+8='
WHERE
key_id = 'f157bb7554cfd559aa667bd8c5342b24ad195dd32b6cd3ca79b10d8ea9100ec8'
AND (
token = 'tB0KoqRYbMVAwZO7uDRRTB/KR3B4Z7GCw06YR9e+D+8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)