UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iAvqlIAueKmQEV1xQ64VmEGU5S4Juhpfgg8bKjTfrWA='
WHERE
key_id = '8f8e27d4d91d88d94f775313c13273d5b79120b4fad4399896e7e043b4aa548e'
AND (
token = 'iAvqlIAueKmQEV1xQ64VmEGU5S4Juhpfgg8bKjTfrWA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)