UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CgjeBhIghTFuGDKBQeyBj/7hwWkfx16+KdE4Laq9FYs='
WHERE
key_id = '3bb3380e82830dae6cbda29f6a7e2764ec0693be673dfcf672c69bd374bd61f4'
AND (
token = 'CgjeBhIghTFuGDKBQeyBj/7hwWkfx16+KdE4Laq9FYs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)