UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KL8NvZiKP6AQ/vMJxJjmlFExNFxaxZQV2IcoVJwW1DU='
WHERE
key_id = '31445cb47930f48a2acc175e769fa5894592ef0b711dcbce36a02be0e5e48738'
AND (
token = 'KL8NvZiKP6AQ/vMJxJjmlFExNFxaxZQV2IcoVJwW1DU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)