UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '48VMJvH+x7KgDXbyZRXB5jX8TQtBNgA+F8CtoS6v3OU=' 
WHERE 
  key_id = 'ef93f7b5fad9e694e5f4c4ae5e4d20ab10c0df908d04d7df65664db28ac4cb00' 
  AND (
    token = '48VMJvH+x7KgDXbyZRXB5jX8TQtBNgA+F8CtoS6v3OU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00038