UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LBr0bfztcm8j7zeerC7PYANVy9dYTrmSxApQMFrLw5E='
WHERE
key_id = '23cacaef5740ed5f2787cff395b469dac5b32e54e9f59c6976aa59bbf77afee1'
AND (
token = 'LBr0bfztcm8j7zeerC7PYANVy9dYTrmSxApQMFrLw5E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)