UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Ej8hAJ31L0vSdWcN8ifE/w7wZ1XvoxaeAN85FJfITlA=' 
WHERE 
  key_id = 'b2bac6fbd41726fd5ec27c596038ac302edd0b315a43d9c41c3d2c6fd945d904' 
  AND (
    token = 'Ej8hAJ31L0vSdWcN8ifE/w7wZ1XvoxaeAN85FJfITlA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035