UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E10V3aS4GI94bcTxDXQS8+h3odTtxksZkctL0aDd2Mo='
WHERE
key_id = 'bc8742046d1ee7ea4456958592c8db6400c74b26536b63038eb26af7cd620849'
AND (
token = 'E10V3aS4GI94bcTxDXQS8+h3odTtxksZkctL0aDd2Mo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)