UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c9uLdaFNBuIDutwOaefapjw5Deg9hLO20iwlSFRhf88='
WHERE
key_id = '787161abecb44a8f6f9f7dacb0bd5e4562ba2c9d2d023079db58c6753c591edc'
AND (
token = 'c9uLdaFNBuIDutwOaefapjw5Deg9hLO20iwlSFRhf88='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)