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