UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NSk4PvkJ90LCh6xzMd1Q4o3z3vx+D1kA7awbE9F18jE='
WHERE
key_id = '43e71d48538e363c35c38e73ab2f837bab2a0b631d533648273de91e8f208137'
AND (
token = 'NSk4PvkJ90LCh6xzMd1Q4o3z3vx+D1kA7awbE9F18jE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)