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

Query time 0.00041