UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '2FrgcR8iOXOff5UrQSpYjh6fD4bQP4Q/gN0Sh9vIOUM=' 
WHERE 
  key_id = '00ea049c9fdb8b476c8e19a5a8fc0221f540273e946e11aaf6d011c3ca0d2e0f' 
  AND (
    token = '2FrgcR8iOXOff5UrQSpYjh6fD4bQP4Q/gN0Sh9vIOUM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00036