UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hpjZsqzy/clP7JWiQbJXoPfQPas4Mju2yPpLeOpL+34='
WHERE
key_id = 'a8e4c0f1783fc0c7fff47fb4426d17c1434d1a384a3f1a7dc81936310be733db'
AND (
token = 'hpjZsqzy/clP7JWiQbJXoPfQPas4Mju2yPpLeOpL+34='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)