UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pNnrmf9EnsSTDqzViDhQScWtR51RJwd0uRIkWvp6lL4='
WHERE
key_id = 'd51d55e937951bf3861725afea70bce0d37cd2d31f58e316b8696b882de05fcf'
AND (
token = 'pNnrmf9EnsSTDqzViDhQScWtR51RJwd0uRIkWvp6lL4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)