UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'uALz0zQe5sYwnAQgacSdC14KwhzlNCvOgAWC7R9BrAY=' 
WHERE 
  key_id = '8208c35e33af98325a566d3f1ce0295008d77da5a148b95fc9edd26e20bf6a87' 
  AND (
    token = 'uALz0zQe5sYwnAQgacSdC14KwhzlNCvOgAWC7R9BrAY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034