UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'm8Ny8ZxdH8q3TBj12rpLl/ORb9Zo8wxk9Y/L0MEAW3s=' 
WHERE 
  key_id = '54aef99b4f83e9cf631ab0ef33c22e14ea63571981b70065870223683ebfaef0' 
  AND (
    token = 'm8Ny8ZxdH8q3TBj12rpLl/ORb9Zo8wxk9Y/L0MEAW3s=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00047