UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fCk993V4MpQSiv0KZ3KQNZj/nyo9ZP1P2P/CYB78+c0='
WHERE
key_id = '2e4240b7e350b070079f396624ca52e1de3eec19fba18ddf8a607f136100cd19'
AND (
token = 'fCk993V4MpQSiv0KZ3KQNZj/nyo9ZP1P2P/CYB78+c0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)