UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9s3uirQS4xSixEg39VIPQdmaWoCwyhfLqdJDZQpzTvA='
WHERE
key_id = 'd3fce47f42c8d8faf44bac31becfcb046b8ecff4173ac0d72abf49204e254def'
AND (
token = '9s3uirQS4xSixEg39VIPQdmaWoCwyhfLqdJDZQpzTvA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)