UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xAl75k6RxddPxBn9964tZUIW8lebPnTVq9T9hzuh/es='
WHERE
key_id = '78786bb73882dd22e092eb477346c29e29cd6d777d056fd046a10e01931761f1'
AND (
token = 'xAl75k6RxddPxBn9964tZUIW8lebPnTVq9T9hzuh/es='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)