UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JlnImcvnMyWBsnEMA8dNLnocVXls9y70EKy1ezeRKvE='
WHERE
key_id = '0b71e645ac0f24b5e1ed9b9303fbe2ad4f0c3f7ffa9db30a868058e0e641f0e0'
AND (
token = 'JlnImcvnMyWBsnEMA8dNLnocVXls9y70EKy1ezeRKvE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)