UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'stNofoEJ27NAFzGn56kPxoivBCFd9DFpPf9Nmshpcr0='
WHERE
key_id = '93d3f379ef5039f333605e6df42f0892489a747faf29890057ba4d35e7fa8bda'
AND (
token = 'stNofoEJ27NAFzGn56kPxoivBCFd9DFpPf9Nmshpcr0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)