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