UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zl4cI2iyLuEYu1rl68usbMUSasd+UmumXl+EQn1s8Qc='
WHERE
key_id = 'cf4f7d11b7ba06e89b9bbc82fc81fc9f30f44ca457472423ce7edf5014e5711c'
AND (
token = 'zl4cI2iyLuEYu1rl68usbMUSasd+UmumXl+EQn1s8Qc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)