UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'piEfiscC4d8gIJq4u6B/uwZdt9pqKkOEoq16TVABQ14='
WHERE
key_id = '737bfd167edece4d5631faeffde0e85a63ff1f3a9b6bcae5e9b0be13bda5bfbe'
AND (
token = 'piEfiscC4d8gIJq4u6B/uwZdt9pqKkOEoq16TVABQ14='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)