UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rsuLZ3vYtQEPGUZndgKqQ8lxQNSaaci5v6SVivakwp4='
WHERE
key_id = 'db0db7ed629239aa3ac51dc7d5bad27a2ef828d1e9acf4b6410cfe5a5630c607'
AND (
token = 'rsuLZ3vYtQEPGUZndgKqQ8lxQNSaaci5v6SVivakwp4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)